Cannot update data in query due to query is the type of query selected.
Cause:
Update queries and queries containing calculations are not updatable. This is by design of Microsoft Access.
Solution:
There is no workaround.
